package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the MM_GOODSRECEIPT_OUTB database table.
 * 
 */
@Entity
@Table(name="MM_GOODSRECEIPT_OUTB")
@NamedQueries({
    @NamedQuery(name = "MmGoodsreceiptOutb.findAll", query = " SELECT c FROM MmGoodsreceiptOutb c order by c.instanceNo,c.company,c.project,c.promisGrnNo,c.status,c.promisStagingId asc"),
    @NamedQuery(name = "MmGoodsreceiptOutb.findById", query = " SELECT c FROM MmGoodsreceiptOutb c WHERE c.promisStagingId = :Id "),
    @NamedQuery(name = "MmGoodsreceiptOutb.findByInstanceNo", query = " SELECT c FROM MmGoodsreceiptOutb c WHERE c.instanceNo = :instanceNo And c.issync = 'N' order by c.instanceNo,c.company,c.project,c.promisGrnNo,c.status,c.promisStagingId asc"),
    @NamedQuery(name = "MmGoodsreceiptOutb.findAllIsSync", query = " SELECT c FROM MmGoodsreceiptOutb c WHERE c.issync = :issync order by c.instanceNo,c.company,c.project,c.promisGrnNo,c.status,c.promisStagingId asc"),
    @NamedQuery(name = "MmGoodsreceiptOutb.findByDocumentNo", query = " SELECT c FROM MmGoodsreceiptOutb c WHERE c.company = :company And c.project = :project And c.promisGrnNo = :promisGrnNo And c.status = :status And c.issync = :issync order by c.instanceNo,c.company,c.project,c.promisGrnNo,c.status,c.promisStagingId asc")
    })
public class MmGoodsreceiptOutb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", length=100)
	private String promisStagingId;
	
	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="ACTION_HANDLER", length=20)
	private String actionHandler;

	@Column(name="ARTICEL_DESCRIPTION", length=300)
	private String articelDescription;

	@Column(name="CREATED_BY", length=30)
	private String createdBy;

	@Column(name="CREATED_ON", length=20)
	private String createdOn;

	@Column(name="EXT_REF_KEY", length=100)
	private String extRefKey;

	@Column(name="EXT_REF_NO", length=100)
	private String extRefNo;

	@Column(name="EXTERNAL_PO_LINE_ITEM", length=5)
	private String externalPoLineItem;

	@Column(name="EXTERNAL_PO_NO", length=10)
	private String externalPoNo;

	@Column(name="GR_DETAIL", length=3)
	private String grDetail;

	@Column(name="GRN_DATE", length=20)
	private String grnDate;

	@Column(name="INSTANCE_NO", length=100)
	private String instanceNo;

	@Column(length=1)
	private String isactive;

	@Column(length=1)
	private String issync;

	@Column(name="ITEM_CODE", length=30)
	private String itemCode;

	@Column(name="ITEM_UM", length=10)
	private String itemUm;

	@Column(name="ITEM_UM_QTY", length=30)
	private String itemUmQty;

	@Column(name="MSG_ACT_RESULT", length=3700)
	private String msgActResult;

	@Column(name="MSG_ALT_DESC", length=3700)
	private String msgAltDesc;

	@Column(name="MSG_CODE", length=1500)
	private String msgCode;

	@Column(name="MSG_DESC", length=3700)
	private String msgDesc;

	@Column(name="PREPARED_BY", length=30)
	private String preparedBy;

	@Column(name="PROJECT_PLANT", length=4)
	private String projectPlant;

	@Column(name="PROMIS_GRN_NO", length=100)
	private String promisGrnNo;	

	@Column(length=300)
	private String remarks;

	@Column(length=30)
	private String status;

	@Column(name="SUPPLIER_DO_DATE", length=20)
	private String supplierDoDate;

	@Column(name="SUPPLIER_DO_NO", length=100)
	private String supplierDoNo;

	@Column(name="SYNC_CREATEDBY", length=100)
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY", length=100)
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UPDATED_BY", length=30)
	private String updatedBy;

	@Column(name="UPDATED_ON", length=20)
	private String updatedOn;
	
	@Column(name="COMPANY")
	private String company;
	
	@Column(name="PROJECT")
	private String project;

	@Column(name="DEL_IND")
	private String delInd;
	
	@Column(name="SAP_PLANT_CODE", length = 4)
	private String sapPlantCode;
	
	@Column(name="SAP_COMPANY_CODE", length = 4)
	private String sapCompanyCode;
	
	@Column(name="SUPPLIER_CODE", length = 100)
	private String supplierCode;
	
	@Column(name="PO_DATE", length = 100)
	private String poDate;
	
	@Column(name="SAP_LIV_NO", length = 100)
	private String sapLivNo;
	
	@Column(name="GRN_TYPE")
	private String grnType;
	
	@Column(name="GRN_SERIES")
	private String grnSeries;
	
	@Column(name="GRN_NO")
	private Long grnNo;
	
	@Column(name="INTERFACE_NO")
	private String interfaceNo;
	
	@Column(name="PROMIS_STATUS")
	private String promisStatus;
	
    /**
	 * @return the promisStatus
	 */
	public String getPromisStatus() {
		return promisStatus;
	}

	/**
	 * @param promisStatus the promisStatus to set
	 */
	public void setPromisStatus(String promisStatus) {
		this.promisStatus = promisStatus;
	}

	/**
	 * @return the interfaceNo
	 */
	public String getInterfaceNo() {
		return interfaceNo;
	}

	/**
	 * @param interfaceNo the interfaceNo to set
	 */
	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}
	
    /**
	 * @return the grnType
	 */
	public String getGrnType() {
		return grnType;
	}

	/**
	 * @param grnType the grnType to set
	 */
	public void setGrnType(String grnType) {
		this.grnType = grnType;
	}

	/**
	 * @return the grnSeries
	 */
	public String getGrnSeries() {
		return grnSeries;
	}

	/**
	 * @param grnSeries the grnSeries to set
	 */
	public void setGrnSeries(String grnSeries) {
		this.grnSeries = grnSeries;
	}

	/**
	 * @return the grnNo
	 */
	public Long getGrnNo() {
		return grnNo;
	}

	/**
	 * @param grnNo the grnNo to set
	 */
	public void setGrnNo(Long grnNo) {
		this.grnNo = grnNo;
	}

	/**
	 * @return the sapLivNo
	 */
	public String getSapLivNo() {
		return sapLivNo;
	}

	/**
	 * @param sapLivNo the sapLivNo to set
	 */
	public void setSapLivNo(String sapLivNo) {
		this.sapLivNo = sapLivNo;
	}

	/**
	 * @return the supplierCode
	 */
	public String getSupplierCode() {
		return supplierCode;
	}

	/**
	 * @param supplierCode the supplierCode to set
	 */
	public void setSupplierCode(String supplierCode) {
		this.supplierCode = supplierCode;
	}

	/**
	 * @return the poDate
	 */
	public String getPoDate() {
		return poDate;
	}

	/**
	 * @param poDate the poDate to set
	 */
	public void setPoDate(String poDate) {
		this.poDate = poDate;
	}

	/**
	 * @return the sapPlantCode
	 */
	public String getSapPlantCode() {
		return sapPlantCode;
	}

	/**
	 * @param sapPlantCode the sapPlantCode to set
	 */
	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	/**
	 * @return the sapCompanyCode
	 */
	public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	/**
	 * @param sapCompanyCode the sapCompanyCode to set
	 */
	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	/**
	 * @return the delInd
	 */
	public String getDelInd() {
		return delInd;
	}

	/**
	 * @param delInd the delInd to set
	 */
	public void setDelInd(String delInd) {
		this.delInd = delInd;
	}

	/**
	 * @return the company
	 */
	public String getCompany() {
		return company;
	}

	/**
	 * @param company the company to set
	 */
	public void setCompany(String company) {
		this.company = company;
	}

	/**
	 * @return the project
	 */
	public String getProject() {
		return project;
	}

	/**
	 * @param project the project to set
	 */
	public void setProject(String project) {
		this.project = project;
	}

	public MmGoodsreceiptOutb() {
    }

	public String getActionHandler() {
		return this.actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getArticelDescription() {
		return this.articelDescription;
	}

	public void setArticelDescription(String articelDescription) {
		this.articelDescription = articelDescription;
	}

	public String getCreatedBy() {
		return this.createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return this.createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getExtRefKey() {
		return this.extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return this.extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getExternalPoLineItem() {
		return this.externalPoLineItem;
	}

	public void setExternalPoLineItem(String externalPoLineItem) {
		this.externalPoLineItem = externalPoLineItem;
	}

	public String getExternalPoNo() {
		return this.externalPoNo;
	}

	public void setExternalPoNo(String externalPoNo) {
		this.externalPoNo = externalPoNo;
	}

	public String getGrDetail() {
		return this.grDetail;
	}

	public void setGrDetail(String grDetail) {
		this.grDetail = grDetail;
	}

	public String getGrnDate() {
		return this.grnDate;
	}

	public void setGrnDate(String grnDate) {
		this.grnDate = grnDate;
	}

	public String getInstanceNo() {
		return this.instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return this.isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return this.issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getItemCode() {
		return this.itemCode;
	}

	public void setItemCode(String itemCode) {
		this.itemCode = itemCode;
	}

	public String getItemUm() {
		return this.itemUm;
	}

	public void setItemUm(String itemUm) {
		this.itemUm = itemUm;
	}

	public String getItemUmQty() {
		return this.itemUmQty;
	}

	public void setItemUmQty(String itemUmQty) {
		this.itemUmQty = itemUmQty;
	}

	public String getMsgActResult() {
		return this.msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return this.msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return this.msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return this.msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPreparedBy() {
		return this.preparedBy;
	}

	public void setPreparedBy(String preparedBy) {
		this.preparedBy = preparedBy;
	}

	public String getProjectPlant() {
		return this.projectPlant;
	}

	public void setProjectPlant(String projectPlant) {
		this.projectPlant = projectPlant;
	}

	public String getPromisGrnNo() {
		return this.promisGrnNo;
	}

	public void setPromisGrnNo(String promisGrnNo) {
		this.promisGrnNo = promisGrnNo;
	}

	public String getPromisStagingId() {
		return this.promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getRemarks() {
		return this.remarks;
	}

	public void setRemarks(String remarks) {
		this.remarks = remarks;
	}

	public String getStatus() {
		return this.status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSupplierDoDate() {
		return this.supplierDoDate;
	}

	public void setSupplierDoDate(String supplierDoDate) {
		this.supplierDoDate = supplierDoDate;
	}

	public String getSupplierDoNo() {
		return this.supplierDoNo;
	}

	public void setSupplierDoNo(String supplierDoNo) {
		this.supplierDoNo = supplierDoNo;
	}

	public String getSyncCreatedby() {
		return this.syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return this.syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return this.syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return this.syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUpdatedBy() {
		return this.updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return this.updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

}